﻿/*
Navicat MySQL Data Transfer

Source Server         : 打
Source Server Version : 50623
Source Host           : localhost:3306
Source Database       : bingo

Target Server Type    : MYSQL
Target Server Version : 50623
File Encoding         : 65001

Date: 2016-08-24 18:53:33
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for app_config
-- ----------------------------
DROP TABLE IF EXISTS `app_config`;
CREATE TABLE `app_config` (
  `Config_Key` varchar(50) DEFAULT NULL,
  `Config_Type` varchar(50) DEFAULT NULL,
  `Config_Value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of app_config
-- ----------------------------

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `Code` int(15) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Parent` int(15) DEFAULT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=300021 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('100000', '中国', 'Country', null);
INSERT INTO `area` VALUES ('200000', '广东省', 'Province', '100000');
INSERT INTO `area` VALUES ('300000', '广州市', 'City', '200000');
INSERT INTO `area` VALUES ('300001', '汕头市', 'City', '200000');
INSERT INTO `area` VALUES ('300002', '湛江市', 'City', '200000');
INSERT INTO `area` VALUES ('300003', '潮州市', 'City', '200000');
INSERT INTO `area` VALUES ('300004', '茂名市', 'City', '200000');
INSERT INTO `area` VALUES ('300005', '深圳市', 'City', '200000');
INSERT INTO `area` VALUES ('300006', '韶关市', 'City', '200000');
INSERT INTO `area` VALUES ('300007', '梅州市', 'City', '200000');
INSERT INTO `area` VALUES ('300008', '惠州市', 'City', '200000');
INSERT INTO `area` VALUES ('300009', '东莞市', 'City', '200000');
INSERT INTO `area` VALUES ('300010', '江门市', 'City', '200000');
INSERT INTO `area` VALUES ('300011', '佛山市', 'City', '200000');
INSERT INTO `area` VALUES ('300012', '肇庆市', 'City', '200000');
INSERT INTO `area` VALUES ('300013', '珠海市', 'City', '200000');
INSERT INTO `area` VALUES ('300014', '中山市', 'City', '200000');
INSERT INTO `area` VALUES ('300015', '河源市', 'City', '200000');
INSERT INTO `area` VALUES ('300016', '汕尾市', 'City', '200000');
INSERT INTO `area` VALUES ('300017', '阳江市', 'City', '200000');
INSERT INTO `area` VALUES ('300018', '清远市', 'City', '200000');
INSERT INTO `area` VALUES ('300019', '揭阳市', 'City', '200000');
INSERT INTO `area` VALUES ('300020', '云浮市', 'City', '200000');

-- ----------------------------
-- Table structure for association
-- ----------------------------
DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
  `Association_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_NO` int(10) DEFAULT NULL,
  `Nature` varchar(100) DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `Association_Grade` varchar(10) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `A_Size_NO` int(15) DEFAULT NULL,
  `Dept_Amount` int(2) DEFAULT NULL,
  `LOGO_Path` varchar(100) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Task_Status` varchar(60) DEFAULT NULL,
  `User_Password` varchar(100) DEFAULT NULL,
  `City_Code` int(15) DEFAULT NULL,
  `Provice_Code` int(15) DEFAULT NULL,
  `City_Name` varchar(200) DEFAULT NULL,
  `Provice_Name` varchar(200) DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `School_Grade_NO` int(15) DEFAULT NULL,
  `School_Grade_Name` varchar(100) DEFAULT NULL,
  `School_Name` varchar(100) DEFAULT NULL,
  `ASize_Discription` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Association_NO`),
  KEY `FKAssociatio856502` (`School_NO`),
  CONSTRAINT `FKAssociatio856502` FOREIGN KEY (`School_NO`) REFERENCES `school` (`School_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=400000001 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association
-- ----------------------------
INSERT INTO `association` VALUES ('400000000', '101', '院级', '体育类', 'Gold', '跆拳道协会黄烈全', '1', '10', '010', 'Active', '顺丰速递', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '3', '1', '潮州市', '广东省', null, '4', '1', '校级', '广州大学华软', null);

-- ----------------------------
-- Table structure for association_student
-- ----------------------------
DROP TABLE IF EXISTS `association_student`;
CREATE TABLE `association_student` (
  `AssociationAssociation_NO` int(10) NOT NULL,
  `StudentStudent_NO` int(10) NOT NULL,
  `Status` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`AssociationAssociation_NO`,`StudentStudent_NO`),
  KEY `FKAssociatio686036` (`AssociationAssociation_NO`),
  KEY `FKAssociatio609651` (`StudentStudent_NO`),
  CONSTRAINT `FKAssociatio609651` FOREIGN KEY (`StudentStudent_NO`) REFERENCES `student` (`Student_NO`),
  CONSTRAINT `FKAssociatio686036` FOREIGN KEY (`AssociationAssociation_NO`) REFERENCES `association` (`Association_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association_student
-- ----------------------------
INSERT INTO `association_student` VALUES ('400000000', '10000001', 'Active');

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `Company_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Company_Name` varchar(60) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `Password` varchar(60) DEFAULT NULL,
  `Web` varchar(100) DEFAULT NULL,
  `Nature` varchar(50) DEFAULT NULL,
  `C_Size` int(15) DEFAULT NULL,
  `Type` varchar(30) DEFAULT NULL,
  `Contact_NO` int(10) NOT NULL,
  `Contact_ID_NO` varchar(20) DEFAULT NULL,
  `License_NO` varchar(120) DEFAULT NULL,
  `License_Name` varchar(120) DEFAULT NULL,
  `License_EndDate` datetime DEFAULT NULL,
  `License_Address` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Grade` varchar(50) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `User_Password` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `CSize_Display_Name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Company_NO`),
  KEY `Company_Name` (`Company_Name`),
  KEY `FKCompany281990` (`Contact_NO`),
  CONSTRAINT `FKCompany281990` FOREIGN KEY (`Contact_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=20000001 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('20000000', 'yui', 'i love yui', '', 'baidu.com', '合资/合作(欧美企业)', '2', '日用消费品', '10000000', '', '3454534534534', '黄烈全', '0001-01-01 00:00:00', '', 'Pending', '', '0', '', '2016-08-20 20:10:37', '', '2016-08-20 20:10:37', '3', '7', '50-149人');

-- ----------------------------
-- Table structure for event_log
-- ----------------------------
DROP TABLE IF EXISTS `event_log`;
CREATE TABLE `event_log` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Instance_ID` varchar(20) DEFAULT NULL,
  `Event_ID` varchar(45) DEFAULT NULL,
  `Action_Type` varchar(45) DEFAULT NULL,
  `Action_Object` varchar(45) DEFAULT NULL,
  `Action_Time` datetime DEFAULT NULL,
  `Operator` varchar(45) DEFAULT NULL,
  `Remark` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of event_log
-- ----------------------------
INSERT INTO `event_log` VALUES ('1', 'SP_A_1', '18825195397', 'SendCAPTCHA', 'UserValidation', '2016-08-20 20:09:07', '18825195397', '{\"ValidID\":0,\"UserID\":null,\"AccountType\":1,\"AccountValue\":\"18825195397\",\"ValidType\":0,\"ValidNo\":\"9551\",\"ValidStatus\":0,\"CreatedTime\":\"2016-08-20T20:08:03.9457909+08:00\",\"UpdatedTime\":\"0001-01-01T00:00:00\"}');
INSERT INTO `event_log` VALUES ('2', 'SP_A_1', 'system', 'Create', 'UserInfo', '2016-08-20 20:09:25', '18825195397', 'UserNO:10000000,UserName:18825195397,NickName:,Password:4dbe3c0dbec4fe8d3009c3b826a6ce2e729d9ec615399c7af237c422beb57b5bcf8a94a65523b94674e3170144abc9ed7aaf8820186684c3befeab8589986387,Role:Company,Sex:Male,CreateTime:');
INSERT INTO `event_log` VALUES ('3', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:10:37', '10000000', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('4', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:10:52', '10000000', 'CompanyNO:20000001,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('5', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:11:27', '10000000', 'CompanyNO:20000002,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('6', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:11:33', '10000000', 'CompanyNO:20000003,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('7', 'SP_A_1', 'system', 'Update', 'UserInfo', '2016-08-20 20:20:57', '10000000', 'UserNO:10000000,UserName:18825195397,NickName:,Password:,Phone:,Email:,QQ:,WeChart:,Role:Company,UserType:,Sex:Female,CreateTime:[2016-08-20 20:09:25]');
INSERT INTO `event_log` VALUES ('8', 'SP_A_1', 'system', 'Update', 'Company', '2016-08-20 20:20:57', '10000000', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Password:,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,ContactIDNO:,LicenseNO:,LicenseName:,LicenseEndDate:,LicenseAddress:,Status:Pending,Remark:,Points:0,Grade:,UpdateTime:[2016-08-20 20:10:37],CreateTime:[2016-08-20 20:10:37],UserPassword:');
INSERT INTO `event_log` VALUES ('9', 'SP_A_1', 'system', 'Update', 'Company', '2016-08-20 20:21:28', '', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Password:,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,ContactIDNO:,LicenseNO:3454534534534,LicenseName:黄烈全,LicenseEndDate:,LicenseAddress:,Status:Pending,Remark:,Points:0,Grade:,UpdateTime:[2016-08-20 20:10:37],CreateTime:[2016-08-20 20:10:37],UserPassword:');
INSERT INTO `event_log` VALUES ('10', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-20 20:29:07', '10000000', 'ProjectNO:30000000,ProjectName:黄烈全,Region:0,Money:10000,StartTime:[2016-08-17 00:00:00],EndTime:[2016-08-09 00:00:00],Entrants:3,EntrantsName:300-499,ProjectRequire:飞洒登封市大发生发射点,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:孙大发大水法,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('11', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-20 23:53:26', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('12', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-21 00:17:59', '10000000', 'ProjectNO:30000002,ProjectName:,Region:0,Money:10000,StartTime:[2016-08-17 00:00:00],EndTime:[2016-08-21 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:534564,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('13', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:05:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-20 23:53:25],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('14', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:07:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:05:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('15', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:19:26', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:07:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('16', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:24:04', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:22,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:19:25],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('17', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:25:45', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:45,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:24:04],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('18', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:28:29', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:454,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:25:45],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('19', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:50:29', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:28:29],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('20', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:01:11', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:20,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:50:29],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('21', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:09:11', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4545,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:01:11],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('22', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:09:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4545,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:09:11],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('23', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:10:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:454,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:09:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('24', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:13:27', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:10:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('25', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 17:55:56', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:13:27],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('26', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:14:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 17:55:56],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('27', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:17:38', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:50,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:14:51],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('28', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:37:16', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:17:38],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('29', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:39:35', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:37:16],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('30', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:41:04', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:20,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:39:35],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('31', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:50:38', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:41:04],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('32', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:53:55', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:22,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:50:37],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('33', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:16:45', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:53:55],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('34', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:25:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:1000,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:16:45],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('35', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:28:27', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:25:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('36', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:29:22', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:28:27],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('37', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:36:35', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:29:22],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('38', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:49:06', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:36:35],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('39', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:59:22', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:222,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:49:06],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('40', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 23:06:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:59:22],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('41', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 08:32:01', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 23:06:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('42', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 14:47:40', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:1,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 08:32:01],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('43', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 14:51:16', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:900000034,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 14:47:40],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('44', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 15:02:42', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 14:51:16],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('45', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 15:03:48', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 15:02:42],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('46', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-23 16:19:18', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 15:03:48],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('47', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 15:24:08', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:ffdsafasfsdafsdf,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-23 16:19:18],MoneyStatus:NoPayment,ActivityAmount:0');

-- ----------------------------
-- Table structure for file_system
-- ----------------------------
DROP TABLE IF EXISTS `file_system`;
CREATE TABLE `file_system` (
  `File_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(50) DEFAULT NULL,
  `Type_Name` varchar(200) DEFAULT NULL,
  `InstanceID` varchar(30) DEFAULT NULL,
  `Path` varchar(500) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Ctreate_Time` datetime DEFAULT NULL,
  `Create_User` int(200) DEFAULT NULL,
  `Old_Name` varchar(300) DEFAULT NULL,
  `New_Name` varchar(300) DEFAULT NULL,
  `Belong_NO` int(15) DEFAULT NULL,
  PRIMARY KEY (`File_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of file_system
-- ----------------------------
INSERT INTO `file_system` VALUES ('1', 'IDFront', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDFront20160820202057.jpg', 'Active', '2016-08-20 20:20:58', '20000000', 'IMG_20160627_183046.jpg', 'IDFront20160820202057.jpg', null);
INSERT INTO `file_system` VALUES ('2', 'IDOpposite', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDOpposite20160820202057.jpg', 'Active', '2016-08-20 20:20:58', '20000000', 'IMG_20160625_182302.jpg', 'IDOpposite20160820202057.jpg', null);
INSERT INTO `file_system` VALUES ('3', 'License', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/License20160820202128.jpg', 'Active', '2016-08-20 20:21:28', '20000000', 'IMG_20160627_203507.jpg', 'License20160820202128.jpg', null);
INSERT INTO `file_system` VALUES ('4', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820202906.jpg', 'Active', '2016-08-20 20:29:07', '20000000', 'IMG_20160613_080451.jpg', 'SponsorBook20160820202906.jpg', null);
INSERT INTO `file_system` VALUES ('5', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820235325.jpg', 'Active', '2016-08-20 23:53:26', '20000000', 'IMG_20160613_080438.jpg', 'SponsorBook20160820235325.jpg', null);
INSERT INTO `file_system` VALUES ('6', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160821001759.jpg', 'Active', '2016-08-21 00:17:59', '20000000', '15913994_mh1467459197242.jpg', 'SponsorBook20160821001759.jpg', null);

-- ----------------------------
-- Table structure for level_rule
-- ----------------------------
DROP TABLE IF EXISTS `level_rule`;
CREATE TABLE `level_rule` (
  `Rule_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Value_From` varchar(60) DEFAULT NULL,
  `Value_To` varchar(60) DEFAULT NULL,
  `Level` varchar(120) DEFAULT NULL,
  `Version` int(10) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Parent_No` int(10) DEFAULT NULL,
  `DisplayOrder` int(4) DEFAULT NULL,
  PRIMARY KEY (`Rule_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=900000112 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of level_rule
-- ----------------------------
INSERT INTO `level_rule` VALUES ('900000001', 'Nature', 'Active', '', '', '校级', null, '校级', null, null);
INSERT INTO `level_rule` VALUES ('900000002', 'Nature', 'Active', '', '', '院级', null, '院级', null, null);
INSERT INTO `level_rule` VALUES ('900000003', 'StudentInterval', 'Active', '0', '100', '1-100', null, '1-100', null, null);
INSERT INTO `level_rule` VALUES ('900000004', 'StudentInterval', 'Active', '101', '300', '101-300', null, '101-300', null, null);
INSERT INTO `level_rule` VALUES ('900000005', 'StudentInterval', 'Active', '301', '500', '301-500', null, '301-500', null, null);
INSERT INTO `level_rule` VALUES ('900000006', 'StudentInterval', 'Active', '501', '1000', '501-1000', null, '501-1000', null, null);
INSERT INTO `level_rule` VALUES ('900000007', 'StudentInterval', 'Active', '1001', '1500', '1001-1500', null, '1001-1500', null, null);
INSERT INTO `level_rule` VALUES ('900000008', 'StudentInterval', 'Active', '1501', '2500', '1501-2500', null, '1501-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000009', 'StudentInterval', 'Active', '2501', '3000', '2501-3000', null, '2501-3000', null, null);
INSERT INTO `level_rule` VALUES ('900000010', 'StudentInterval', 'Active', '3000', '3000000000', '3000以上', null, '3000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000011', 'SponsorMoney', 'Active', '500', '2500', '500-2500', null, '500-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000012', 'SponsorMoney', 'Active', '2501', '5000', '2501-5000', null, '2501-5000', null, null);
INSERT INTO `level_rule` VALUES ('900000013', 'SponsorMoney', 'Active', '5001', '7500', '5001-7500', null, '5001-7500', null, null);
INSERT INTO `level_rule` VALUES ('900000014', 'SponsorMoney', 'Active', '7501', '10000', '7501-10000', null, '7501-10000', null, null);
INSERT INTO `level_rule` VALUES ('900000015', 'SponsorMoney', 'Active', '10001', '15000', '10001-15000', null, '10001-15000', null, null);
INSERT INTO `level_rule` VALUES ('900000016', 'SponsorMoney', 'Active', '15001', '20000', '15001-20000', null, '15001-20000', null, null);
INSERT INTO `level_rule` VALUES ('900000017', 'SponsorMoney', 'Active', '20001', '25000', '20001-25000', null, '20001-25000', null, null);
INSERT INTO `level_rule` VALUES ('900000018', 'SponsorMoney', 'Active', '25001', '30000', '25001-30000', null, '25001-30000', null, null);
INSERT INTO `level_rule` VALUES ('900000019', 'SponsorMoney', 'Active', '30001', '50000', '30001-50000', null, '30001-50000', null, null);
INSERT INTO `level_rule` VALUES ('900000020', 'SponsorMoney', 'Active', '50001', '70000', '50001-70000', null, '50001-70000', null, null);
INSERT INTO `level_rule` VALUES ('900000021', 'SponsorMoney', 'Active', '70001', '100000', '70001-100000', null, '70001-100000', null, null);
INSERT INTO `level_rule` VALUES ('900000022', 'SponsorMoney', 'Active', '100001', '150000', '100001-150000', null, '100001-150000', null, null);
INSERT INTO `level_rule` VALUES ('900000023', 'SponsorMoney', 'Active', '150001', '200000', '150001-200000', null, '150001-200000', null, null);
INSERT INTO `level_rule` VALUES ('900000024', 'SponsorMoney', 'Active', '200000', '200000000', '200000以上', null, '200000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000025', 'StudentLevel', 'Active', '', '', '官方代理社团', null, '官方代理社团', null, null);
INSERT INTO `level_rule` VALUES ('900000026', 'StudentLevel', 'Active', '500', '5000000', '金牌社团', null, '金牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000027', 'StudentLevel', 'Active', '400', '500', '银牌社团', null, '银牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000028', 'StudentLevel', 'Active', '300', '400', '铜牌社团', null, '铜牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000029', 'StudentLevel', 'Active', '200', '300', '普通社团V3', null, '普通社团V3', null, null);
INSERT INTO `level_rule` VALUES ('900000030', 'StudentLevel', 'Active', '100', '200', '普通社团V2', null, '普通社团V2', null, null);
INSERT INTO `level_rule` VALUES ('900000031', 'StudentLevel', 'Active', '0', '100', '普通社团V1', null, '普通社团V1', null, null);
INSERT INTO `level_rule` VALUES ('900000032', 'SponsorMoney', 'Active', '', '', '2000', null, '2000', null, null);
INSERT INTO `level_rule` VALUES ('900000033', 'SponsorMultiple', 'Active', '', '', '5', null, '5', null, null);
INSERT INTO `level_rule` VALUES ('900000034', 'CancelRemark', 'Active', '', '', '活动信息错误', null, '活动信息错误', null, null);
INSERT INTO `level_rule` VALUES ('900000035', 'CancelRemark', 'Active', '', '', '活动长时间没收到邀请', null, '活动长时间没收到邀请', null, null);
INSERT INTO `level_rule` VALUES ('900000036', 'CancelRemark', 'Active', '', '', '活动需要重新发布', null, '活动需要重新发布', null, null);
INSERT INTO `level_rule` VALUES ('900000037', 'CancelRemark', 'Active', '', '', '活动已达成目的', null, '活动已达成目的', null, null);
INSERT INTO `level_rule` VALUES ('900000038', 'CancelRemark', 'Active', '', '', '活动时间过期', null, '活动时间过期', null, null);
INSERT INTO `level_rule` VALUES ('900000039', 'CancelRemark', 'Active', '', '', '用户自主下架', null, '用户自主下架', null, null);
INSERT INTO `level_rule` VALUES ('900000040', 'ActivityType', 'Active', '', '', '招新类', null, '招新类', null, null);
INSERT INTO `level_rule` VALUES ('900000041', 'ActivityType', 'Active', '', '', '文艺类', null, '文艺类', null, null);
INSERT INTO `level_rule` VALUES ('900000042', 'ActivityType', 'Active', '', '', '表演类', null, '表演类', null, null);
INSERT INTO `level_rule` VALUES ('900000043', 'ActivityType', 'Active', '', '', '晚会类 ', null, '晚会类 ', null, null);
INSERT INTO `level_rule` VALUES ('900000044', 'ActivityType', 'Active', '', '', '体育类', null, '体育类', null, null);
INSERT INTO `level_rule` VALUES ('900000045', 'ActivityType', 'Active', '', '', '讲座类', null, '讲座类', null, null);
INSERT INTO `level_rule` VALUES ('900000046', 'ActivityType', 'Active', '', '', '比赛类', null, '比赛类', null, null);
INSERT INTO `level_rule` VALUES ('900000047', 'ActivityType', 'Active', '', '', '其它', null, '其它', null, null);
INSERT INTO `level_rule` VALUES ('900000048', 'AssosiationType', 'Active', '', '', '组织类-学生会', null, '组织类-学生会', null, null);
INSERT INTO `level_rule` VALUES ('900000049', 'AssosiationType', 'Active', '', '', '组织类-团委', null, '组织类-团委', null, null);
INSERT INTO `level_rule` VALUES ('900000050', 'AssosiationType', 'Active', '', '', '组织类-社团联合会', null, '组织类-社团联合会', null, null);
INSERT INTO `level_rule` VALUES ('900000051', 'AssosiationType', 'Active', '', '', '组织类-其他', null, '组织类-其他', null, null);
INSERT INTO `level_rule` VALUES ('900000052', 'AssosiationType', 'Active', '', '', '社团类-青年志愿者服务队', null, '社团类-青年志愿者服务队', null, null);
INSERT INTO `level_rule` VALUES ('900000053', 'AssosiationType', 'Active', '', '', '社团类-红十字会', null, '社团类-红十字会', null, null);
INSERT INTO `level_rule` VALUES ('900000054', 'AssosiationType', 'Active', '', '', '社团类-体育类社团', null, '社团类-体育类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000055', 'AssosiationType', 'Active', '', '', '社团类-棋牌类社团', null, '社团类-棋牌类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000056', 'AssosiationType', 'Active', '', '', '社团类-动漫社', null, '社团类-动漫社', null, null);
INSERT INTO `level_rule` VALUES ('900000057', 'AssosiationType', 'Active', '', '', '社团类-文娱类社团', null, '社团类-文娱类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000058', 'AssosiationType', 'Active', '', '', '社团类-兴趣类社团', null, '社团类-兴趣类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000059', 'AssosiationType', 'Active', '', '', '社团类-其他社团', null, '社团类-其他社团', null, null);
INSERT INTO `level_rule` VALUES ('900000060', 'CompanyMaterial', 'Active', '', '', '公司产品', null, '公司产品', null, null);
INSERT INTO `level_rule` VALUES ('900000061', 'CompanyMaterial', 'Active', '', '', '传单 ', null, '传单 ', null, null);
INSERT INTO `level_rule` VALUES ('900000062', 'CompanyMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000063', 'CompanyMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000064', 'CompanyMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000065', 'CompanyMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000066', 'CompanyMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000067', 'CompanyMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000068', 'CompanyMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000069', 'AssociationMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000070', 'AssociationMaterial', 'Active', '', '', '传单(黑白，彩色)', null, '传单(黑白，彩色)', null, null);
INSERT INTO `level_rule` VALUES ('900000071', 'AssociationMaterial', 'Active', '', '', 'KT板', null, 'KT板', null, null);
INSERT INTO `level_rule` VALUES ('900000072', 'AssociationMaterial', 'Active', '', '', '幕布', null, '幕布', null, null);
INSERT INTO `level_rule` VALUES ('900000073', 'AssociationMaterial', 'Active', '', '', '易拉宝', null, '易拉宝', null, null);
INSERT INTO `level_rule` VALUES ('900000074', 'AssociationMaterial', 'Active', '', '', '推头', null, '推头', null, null);
INSERT INTO `level_rule` VALUES ('900000075', 'AssociationMaterial', 'Active', '', '', '灯布', null, '灯布', null, null);
INSERT INTO `level_rule` VALUES ('900000076', 'AssociationMaterial', 'Active', '', '', '木构', null, '木构', null, null);
INSERT INTO `level_rule` VALUES ('900000077', 'AssociationMaterial', 'Active', '', '', '展位', null, '展位', null, null);
INSERT INTO `level_rule` VALUES ('900000078', 'AssociationMaterial', 'Active', '', '', '灯箱', null, '灯箱', null, null);
INSERT INTO `level_rule` VALUES ('900000079', 'AssociationMaterial', 'Active', '', '', '桁架', null, '桁架', null, null);
INSERT INTO `level_rule` VALUES ('900000080', 'AssociationMaterial', 'Active', '', '', '麦克风(耳麦，手麦，麦架)', null, '麦克风(耳麦，手麦，麦架)', null, null);
INSERT INTO `level_rule` VALUES ('900000081', 'AssociationMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000082', 'AssociationMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000083', 'AssociationMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000084', 'AssociationMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000085', 'AssociationMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000086', 'AssociationMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000087', 'CheckCompanyRejectedRemark', 'Active', '', '', '不存在您所输入的代理官口号令', null, '不存在您所输入的代理官口号令', null, null);
INSERT INTO `level_rule` VALUES ('900000088', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业全称与营业执照上的不一致', null, '企业全称与营业执照上的不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000089', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业地址不详细', null, '企业地址不详细', null, null);
INSERT INTO `level_rule` VALUES ('900000090', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业网址无法正常打开或网站内容不全', null, '企业网址无法正常打开或网站内容不全', null, null);
INSERT INTO `level_rule` VALUES ('900000091', 'CheckCompanyRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000092', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000093', 'CheckCompanyRejectedRemark', 'Active', '', '', '执照名称或注册号与营业执照不一致', null, '执照名称或注册号与营业执照不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000094', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的营业执照', null, '未上传正确的营业执照', null, null);
INSERT INTO `level_rule` VALUES ('900000095', 'CheckCompanyRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000096', 'CheckAssociationRejectedRemark', 'Active', '', '', '所属院系不正确或不存在', null, '所属院系不正确或不存在', null, null);
INSERT INTO `level_rule` VALUES ('900000097', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000098', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人学号与学生证不一致', null, '注册人学号与学生证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000099', 'CheckAssociationRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000100', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000101', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的学生证', null, '未上传正确的学生证', null, null);
INSERT INTO `level_rule` VALUES ('900000102', 'AssociationSize', 'Active', '1', '10', '1-10人', null, '1-10人', null, null);
INSERT INTO `level_rule` VALUES ('900000103', 'AssociationSize', 'Active', '11', '30', '11-30人', null, '11-30人', null, null);
INSERT INTO `level_rule` VALUES ('900000104', 'AssociationSize', 'Active', '31', '60', '31-60人', null, '31-60人', null, null);
INSERT INTO `level_rule` VALUES ('900000105', 'AssociationSize', 'Active', '61', '90', '61-90人', null, '61-90人', null, null);
INSERT INTO `level_rule` VALUES ('900000106', 'AssociationSize', 'Active', '91', '120', '91-120人', null, '91-120人', null, null);
INSERT INTO `level_rule` VALUES ('900000107', 'AssociationSize', 'Active', '121', '150', '121-150人', null, '121-150人', null, null);
INSERT INTO `level_rule` VALUES ('900000108', 'AssociationSize', 'Active', '151', '200', '151-200人', null, '151-200人', null, null);
INSERT INTO `level_rule` VALUES ('900000109', 'AssociationSize', 'Active', '201', '250', '201-250人', null, '201-250人', null, null);
INSERT INTO `level_rule` VALUES ('900000110', 'AssociationSize', 'Active', '251', '300', '251-300人', null, '251-300人', null, null);
INSERT INTO `level_rule` VALUES ('900000111', 'AssociationSize', 'Active', '300', '1000000', '300以上', null, '300以上', null, null);
INSERT INTO `level_rule` VALUES ('900000112', 'AssociationSchoolType', 'Active', '', '', '组织类', null, '组织类', null, null);
INSERT INTO `level_rule` VALUES ('900000113', 'AssociationSchoolType', 'Active', '', '', '社团类', null, '社团类', null, null); 


-- ----------------------------
-- Table structure for lifecycle_event
-- ----------------------------
DROP TABLE IF EXISTS `lifecycle_event`;
CREATE TABLE `lifecycle_event` (
  `ID` int(15) NOT NULL AUTO_INCREMENT,
  `Role_ID` int(15) DEFAULT NULL,
  `Fun` varchar(255) DEFAULT NULL,
  `Value_From` varchar(255) DEFAULT NULL,
  `Value_To` varchar(255) DEFAULT NULL,
  `Updated_Time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `Updated_User` int(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lifecycle_event
-- ----------------------------

-- ----------------------------
-- Table structure for money
-- ----------------------------
DROP TABLE IF EXISTS `money`;
CREATE TABLE `money` (
  `Role_NO` int(10) DEFAULT NULL,
  `Fun` varchar(30) DEFAULT NULL,
  `Count_Money` double DEFAULT NULL,
  `balance` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money
-- ----------------------------

-- ----------------------------
-- Table structure for money_log
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `NO` varchar(40) DEFAULT NULL,
  `Type` varchar(40) DEFAULT NULL,
  `Value_From` varchar(100) DEFAULT NULL,
  `Value_To` varchar(100) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `update_Time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money_log
-- ----------------------------

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `Project_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Project_Name` varchar(60) DEFAULT NULL,
  `Province` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  `Money` double(11,0) DEFAULT NULL,
  `Money_Name` varchar(100) DEFAULT NULL,
  `Material` varchar(255) DEFAULT NULL,
  `Start_Time` datetime DEFAULT NULL,
  `End_Time` datetime DEFAULT NULL,
  `Entrants` int(11) DEFAULT NULL,
  `Entrants_Name` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Project_Require` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Book_Status` varchar(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Readers` int(10) DEFAULT NULL,
  `Liked_Count` int(11) DEFAULT NULL,
  `Belong_NO` int(10) DEFAULT NULL,
  `Belong_Type` varchar(30) DEFAULT NULL,
  `Belong_Contact_NO` int(10) DEFAULT NULL,
  `Nature` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Urgent_Remark` varchar(255) DEFAULT NULL,
  `Money_Status` varchar(70) DEFAULT NULL,
  PRIMARY KEY (`Project_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=30000003 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES ('30000000', '第十一届科技学术节', '', '潮州市', '900000014', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '3', '300-499', '2016-08-20 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Approving', 'Active', null, '0', '10', '400000000', 'Student', '10000001', '', '晚会类$%#体育类', '孙大发大水法', 'NoPayment');
INSERT INTO `project` VALUES ('30000001', '现货白银赞助书', '', '', '10000', '', '', '2016-08-02 00:00:00', '2016-08-02 00:00:00', '10', '100-299', '2016-08-20 23:53:25', '2016-08-24 15:24:08', 'ffdsafasfsdafsdf', 'Cancel', 'Active', '活动信息错误', '0', '0', '20000000', 'Company', '10000000', '', '', '3453453', 'NoPayment');
INSERT INTO `project` VALUES ('30000002', '广东省白银大赛赞助书', '', '汕头市', '10000', null, '传单', '2016-08-17 00:00:00', '2016-08-21 00:00:00', '2', '100-299', '2016-08-21 00:17:59', '2016-08-21 00:17:59', '', 'Approving', 'Pending', '真的是傻逼来着', '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类', '534564', 'NoPayment');

-- ----------------------------
-- Table structure for project_extend
-- ----------------------------
DROP TABLE IF EXISTS `project_extend`;
CREATE TABLE `project_extend` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Code` int(20) DEFAULT NULL,
  `Value` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_extend
-- ----------------------------
INSERT INTO `project_extend` VALUES ('30000000', 'Type', '3', '晚会类');
INSERT INTO `project_extend` VALUES ('30000000', 'Type', '21', '体育类');
INSERT INTO `project_extend` VALUES ('30000000', 'Material', '2', '传单');
INSERT INTO `project_extend` VALUES ('30000000', 'City', '4', '潮州市');
INSERT INTO `project_extend` VALUES ('30000001', 'Type', '2', '表演类');
INSERT INTO `project_extend` VALUES ('30000001', 'Type', '4', '体育类');
INSERT INTO `project_extend` VALUES ('30000001', 'Material', '2', '传单');
INSERT INTO `project_extend` VALUES ('30000001', 'Material', '3', '海报');
INSERT INTO `project_extend` VALUES ('30000001', 'City', '3', '湛江市');
INSERT INTO `project_extend` VALUES ('30000001', 'City', '11', '江门市');
INSERT INTO `project_extend` VALUES ('30000002', 'Type', '2', '表演类');
INSERT INTO `project_extend` VALUES ('30000002', 'Type', '3', '晚会类');
INSERT INTO `project_extend` VALUES ('30000002', 'Material', '2', '传单');
INSERT INTO `project_extend` VALUES ('30000002', 'City', '2', '汕头市');

-- ----------------------------
-- Table structure for project_field
-- ----------------------------
DROP TABLE IF EXISTS `project_field`;
CREATE TABLE `project_field` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(60) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `From_User` varchar(15) DEFAULT NULL,
  `To_User` varchar(15) DEFAULT NULL,
  `Field_Value` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  KEY `FKProject_Fi868447` (`Project_NO`),
  CONSTRAINT `FKProject_Fi868447` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_field
-- ----------------------------
INSERT INTO `project_field` VALUES ('30000001', 'FirstFeedback', 'Active', null, '25', '2244', '2016-08-22 11:37:53');
INSERT INTO `project_field` VALUES ('30000000', 'FirstFeedback', 'Active', null, '25', 'hhhhh', '2016-08-22 11:37:53');

-- ----------------------------
-- Table structure for project_items
-- ----------------------------
DROP TABLE IF EXISTS `project_items`;
CREATE TABLE `project_items` (
  `Project_NO` int(15) DEFAULT NULL,
  `Intention_Role` varchar(30) DEFAULT NULL,
  `Intention_Role_NO` varchar(15) DEFAULT NULL,
  `Intention_Contact_NO` varchar(15) DEFAULT NULL,
  `Status` varchar(15) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Remarks` varchar(255) DEFAULT NULL,
  `Is_Student_Confirm` int(1) DEFAULT NULL,
  `Student_Book_Remark` varchar(400) DEFAULT NULL,
  `Is_Company_Confirm` int(1) DEFAULT NULL,
  `Company_Book_Remark` varchar(400) DEFAULT NULL,
  `Urgent_Remark` varchar(400) DEFAULT NULL,
  `ContractNO` varchar(40) DEFAULT NULL,
  `Have_Offline_Team` int(1) DEFAULT NULL,
  `Have_Invoice` int(1) DEFAULT NULL,
  `Project_NO_Self` int(15) DEFAULT NULL,
  `Project_Self_Status` varchar(100) DEFAULT NULL,
  `Intention_Name` varchar(255) DEFAULT NULL,
  `Choose_Type` varchar(100) DEFAULT NULL,
  `Money_Status` varchar(100) DEFAULT NULL,
  `Project_Item_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Submit_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Project_Item_NO`),
  KEY `FKProject_It966760` (`Project_NO`),
  CONSTRAINT `FKProject_It966760` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_items
-- ----------------------------
INSERT INTO `project_items` VALUES ('30000001', 'Student', '400000000', '10000001', 'Cancel', '2016-08-21 23:07:10', '2016-08-21 23:07:10', '', '0', '', '0', '', '', '', '0', '0', '30000000', null, '', 'StudentChoose', 'NoPayment', '1', '2016-08-21 23:07:10');
INSERT INTO `project_items` VALUES ('30000000', 'Company', '20000000', '10000000', 'Approving', '2016-08-21 23:07:10', '2016-08-21 23:07:10', '', '0', '', '0', '', '', '', '0', '0', '30000001', '', '', 'CompanyChoose', 'NoPayment', '2', '0001-01-01 00:00:00');

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `School_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_Name` varchar(60) DEFAULT NULL,
  `Student_SIze` int(11) DEFAULT NULL,
  `Province` varchar(25) DEFAULT NULL,
  `City` varchar(25) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`School_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of school
-- ----------------------------
INSERT INTO `school` VALUES ('101', '', null, null, null, null);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `Student_NO` int(10) NOT NULL,
  `Student_LD_Number` varchar(16) DEFAULT NULL,
  `Student_Grade` varchar(10) DEFAULT NULL,
  `Ident_Type` varchar(20) DEFAULT NULL,
  `Ident_NO` varchar(20) DEFAULT NULL,
  `Bank_NO` varchar(30) DEFAULT NULL,
  `AliPay_NO` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Student_NO`),
  KEY `FKStudent321838` (`Student_NO`),
  CONSTRAINT `FKStudent321838` FOREIGN KEY (`Student_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('10000001', null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `User_No` int(10) NOT NULL AUTO_INCREMENT,
  `User_Name` varchar(60) DEFAULT NULL,
  `NickName` varchar(60) DEFAULT NULL,
  `Password` varchar(180) DEFAULT NULL,
  `Phone` varchar(18) DEFAULT NULL,
  `QQ` varchar(20) DEFAULT NULL,
  `WeChart` varchar(30) DEFAULT NULL,
  `Role` varchar(30) DEFAULT NULL,
  `User_Type` varchar(15) DEFAULT NULL,
  `Sex` varchar(8) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=10000002 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('10000000', '18825195397', '', '4dbe3c0dbec4fe8d3009c3b826a6ce2e729d9ec615399c7af237c422beb57b5bcf8a94a65523b94674e3170144abc9ed7aaf8820186684c3befeab8589986387', '', '', '', 'Company', '', 'Female', '', '2016-08-20 20:20:57');
INSERT INTO `user_info` VALUES ('10000001', '18825195398', '', '4dbe3c0dbec4fe8d3009c3b826a6ce2e729d9ec615399c7af237c422beb57b5bcf8a94a65523b94674e3170144abc9ed7aaf8820186684c3befeab8589986387', '', '', '', 'Student', '', 'Female', '', '2016-08-20 20:20:57');

-- ----------------------------
-- Table structure for user_validation
-- ----------------------------
DROP TABLE IF EXISTS `user_validation`;
CREATE TABLE `user_validation` (
  `Valid_ID` int(10) NOT NULL AUTO_INCREMENT,
  `User_ID` varchar(60) DEFAULT NULL,
  `Account_Type` varchar(10) DEFAULT NULL,
  `Account_Value` varchar(100) DEFAULT NULL,
  `Valid_Type` varchar(30) DEFAULT NULL,
  `Valid_No` varchar(300) DEFAULT NULL,
  `Valid_Status` varchar(20) DEFAULT NULL,
  `Created_Time` datetime DEFAULT NULL,
  `Updated_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Valid_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_validation
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;
